﻿<%@ Page Title="" Language="C#" MasterPageFile="~/companypart/CompanyMastermaster.master" AutoEventWireup="true" CodeFile="SubHistoryrep.aspx.cs" Inherits="companypart_SubHistoryrep"meta:resourcekey="PageResource1" %>

<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">
<title>تقارير الاشتراكات</title>
    <style type="text/css">
    tr .tabbone4{
	 background-color:#028ac5;
	 font-size:11px;
	 line-height:20px;
	 font-family:Tahoma;
  	 color:#fff;
  	 text-align:right;
	
}
.adel4{
	background-color:#ededed;
	font-size:10px;
	color:#084f86;
	font-family:Tahoma;
	height:30px;
	text-align:  right;
}
         .zr3 {
	background-image:url('../images/button2.png');
	display:block;
	float:right;
	 padding: 0px 10px 0px 10px;
	height:21px;
	text-align:center;
	color:#fff;
	text-shadow:1px 1px 0px #003a5e;
	margin-right:2px;
	line-height:19px;
	font-weight:bold;
	text-decoration:none;
	font-family:Tahoma;
	font-size:12px;


}
.zr3:hover ,.zr3:active {
	background-image:url('../images/button2.png');
	text-shadow:1px 1px 0px #003a5e;
	background-position:0px -21px;
	
}
  .stylelabel3
       {
       	color:#064c66;
	 font-weight:bold;
	 direction:rtl;
	 text-align:right;
       	}
             .tab3{
	width:815px;
 direction:rtl;
 border:1px #ccc solid;
 border-radius:5px;
 }

tr .tabbone3{
	 background-color:#028ac5;
	 font-size:11px;
	 line-height:20px;
	 font-family:Tahoma;
  	 color:#fff;
  	 text-align:center;
	
}
 .req3
       {
           color:Red;
       } 
.adel3{
	background-color:#ededed;
	font-size:10px;
	color:#084f86;
	font-family:Tahoma;
	height:30px;
	text-align:  center;
}
.he3{
	background-color:#fff;
	padding:5px;
	font-family:Tahoma;
	font-size:14px;
	font-weight:bold;
}
.txt3
{
    border:1px solid black;
    }
        

        .lok
     {
	display: none;
	color: red;
     }
        .jqmWindow {
    display: none;
    
    position: fixed;
    top: 17%;
    left: 50%;
    
    margin-left: -300px;
    width: 800px;
    
    background-color: #EEE;
    color: #333;
    border: 1px solid black;
    padding: 12px;
}
    </style>
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
    <br />
  <table  dir="rtl">
    <tr>

        <td>
<asp:GridView ID="GridView1" runat="server" 
        DataSourceID="SqlDataSource1" 
        AutoGenerateColumns="False" DataKeyNames="id" 
        onrowdatabound="GridView1_RowDataBound" 
    onrowcreated="GridView1_RowCreated1" EnableModelValidation="True" GridLines="None">
        <Columns>
        
        
                <asp:TemplateField>
                            <HeaderTemplate>
                                <table class="tab3">
                                    <tr class="tabbone3">
                                    <td style="width:200px">
                                        <asp:Label ID="lblpaidfees" runat="server" Text="النقود المدفوعة" meta:resourceKey="lblpaidfees" />
                                            
                                        </td>
                                        <td style="width:200px">
                                     <asp:Label ID="lblstartofsubs" runat="server" Text="بداية الاشتراك" meta:resourceKey="lblstartofsubs" />
                                            
                                        </td>

                                        <td style="width:200px">
                                     <asp:Label ID="lblendofsubs" runat="server" Text="نهاية الاشتراك" meta:resourceKey="lblendofsubs" />
                                            
                                        </td>
                                    <td style="width:200px">
                                     <asp:Label  ID="lblstops" runat="server" Text="سارى/منتهى" meta:resourceKey="lblstops" />
                                            
                                        </td>
                                  <%--<td width="20%">
                                     <asp:Label  ID="Label1" runat="server" Text="عدد المتابعات الحالية" meta:resourceKey="lblstop" />
                                            
                                        </td>--%>
                                     
                                     
                                        
                                      
                                    </tr>
                                </table>
                            </HeaderTemplate>
                            <ItemTemplate>
                              
                             
                                    <table class="tab3">
                                        <tr class="adel3">
                                        <td style="width:200px">
                                                <asp:Label  ID="paidfees" runat="server" Text='<%# HttpUtility.HtmlEncode(Convert.ToString(Eval("paidfees"))) %>' />
                                            </td>
                                             <td style="width:200px">
                                                <asp:Label  ID="startofsub" runat="server" Text='<%# HttpUtility.HtmlEncode(Convert.ToString(Eval("startofsub"))) %>' />
                                            </td>

                                            <td style="width:200px">
                                                <asp:Label ID="endofsub" runat="server" Text='<%# Eval("endofsub") %>' />
                                            </td>

                                        <td style="width:200px">
                                         <asp:CheckBox runat="server" ID="chkAdd" ToolTip='<%# Eval("id") %>'  ></asp:CheckBox> 
                                             <asp:Label runat="server" ID="edits"     />
                                            </td>
                                        </tr>
                                    </table>
                                    </ItemTemplate>
                </asp:TemplateField>
      
        </Columns>
    </asp:GridView>
    
       <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
        ConnectionString="<%$ ConnectionStrings:ConnectionString %>" 
        SelectCommand="SELECT [id],[startofsub], [endofsub], [paidfees] FROM [subscriptions]   WHERE ([company_id] = @company_id) ">
         <SelectParameters>
            <asp:SessionParameter Name="company_id" SessionField="company_id" />
        </SelectParameters>
          </asp:SqlDataSource>
            </td>
                </tr>
          <tr>
                <td  align="center"> 
                <asp:Button CssClass="zr3" ID="genreport" runat="server" Text="انشىء التقرير" 
            onclick="genreport_Click" meta:resourceKey="genreport" />
                </td>
                </tr>
</table>
</asp:Content>

